[dbo].[BAEHistoryAdd]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEHistoryAdd

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ip	varchar(128)	128
@description	varchar(1024)	1024
@eventType	varchar(256)	256

SQL Script

create procedure [dbo].[BAEHistoryAdd] @ip as
varchar(128),
    @description AS varchar(1024),
    @eventType AS varchar(256)
AS
    INSERT INTO History
    (History.EventDate, History.IP, History.[Description], History.EventType)
    VALUES
    (GETDATE(), @ip, @description, @eventType);

    SELECT (CAST (@@IDENTITY AS int)) AS 'HistoryId'

GO

Uses

[dbo].[History]
dbo